/*
 Navicat Premium Data Transfer

 Source Server         : LaoFu
 Source Server Type    : MySQL
 Source Server Version : 50726
 Source Host           : localhost:3306
 Source Schema         : build_manage

 Target Server Type    : MySQL
 Target Server Version : 50726
 File Encoding         : 65001

 Date: 24/03/2021 15:48:14
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for auth_group
-- ----------------------------
DROP TABLE IF EXISTS `auth_group`;
CREATE TABLE `auth_group` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(150) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `name` (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of auth_group
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for auth_group_permissions
-- ----------------------------
DROP TABLE IF EXISTS `auth_group_permissions`;
CREATE TABLE `auth_group_permissions` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `group_id` int(11) NOT NULL,
  `permission_id` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `auth_group_permissions_group_id_permission_id_0cd325b0_uniq` (`group_id`,`permission_id`),
  KEY `auth_group_permissio_permission_id_84c5c92e_fk_auth_perm` (`permission_id`),
  CONSTRAINT `auth_group_permissio_permission_id_84c5c92e_fk_auth_perm` FOREIGN KEY (`permission_id`) REFERENCES `auth_permission` (`id`),
  CONSTRAINT `auth_group_permissions_group_id_b120cbf9_fk_auth_group_id` FOREIGN KEY (`group_id`) REFERENCES `auth_group` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of auth_group_permissions
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for auth_permission
-- ----------------------------
DROP TABLE IF EXISTS `auth_permission`;
CREATE TABLE `auth_permission` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `content_type_id` int(11) NOT NULL,
  `codename` varchar(100) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `auth_permission_content_type_id_codename_01ab375a_uniq` (`content_type_id`,`codename`),
  CONSTRAINT `auth_permission_content_type_id_2f476e4b_fk_django_co` FOREIGN KEY (`content_type_id`) REFERENCES `django_content_type` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=45 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of auth_permission
-- ----------------------------
BEGIN;
INSERT INTO `auth_permission` VALUES (1, 'Can add log entry', 1, 'add_logentry');
INSERT INTO `auth_permission` VALUES (2, 'Can change log entry', 1, 'change_logentry');
INSERT INTO `auth_permission` VALUES (3, 'Can delete log entry', 1, 'delete_logentry');
INSERT INTO `auth_permission` VALUES (4, 'Can view log entry', 1, 'view_logentry');
INSERT INTO `auth_permission` VALUES (5, 'Can add permission', 2, 'add_permission');
INSERT INTO `auth_permission` VALUES (6, 'Can change permission', 2, 'change_permission');
INSERT INTO `auth_permission` VALUES (7, 'Can delete permission', 2, 'delete_permission');
INSERT INTO `auth_permission` VALUES (8, 'Can view permission', 2, 'view_permission');
INSERT INTO `auth_permission` VALUES (9, 'Can add group', 3, 'add_group');
INSERT INTO `auth_permission` VALUES (10, 'Can change group', 3, 'change_group');
INSERT INTO `auth_permission` VALUES (11, 'Can delete group', 3, 'delete_group');
INSERT INTO `auth_permission` VALUES (12, 'Can view group', 3, 'view_group');
INSERT INTO `auth_permission` VALUES (13, 'Can add user', 4, 'add_user');
INSERT INTO `auth_permission` VALUES (14, 'Can change user', 4, 'change_user');
INSERT INTO `auth_permission` VALUES (15, 'Can delete user', 4, 'delete_user');
INSERT INTO `auth_permission` VALUES (16, 'Can view user', 4, 'view_user');
INSERT INTO `auth_permission` VALUES (17, 'Can add content type', 5, 'add_contenttype');
INSERT INTO `auth_permission` VALUES (18, 'Can change content type', 5, 'change_contenttype');
INSERT INTO `auth_permission` VALUES (19, 'Can delete content type', 5, 'delete_contenttype');
INSERT INTO `auth_permission` VALUES (20, 'Can view content type', 5, 'view_contenttype');
INSERT INTO `auth_permission` VALUES (21, 'Can add session', 6, 'add_session');
INSERT INTO `auth_permission` VALUES (22, 'Can change session', 6, 'change_session');
INSERT INTO `auth_permission` VALUES (23, 'Can delete session', 6, 'delete_session');
INSERT INTO `auth_permission` VALUES (24, 'Can view session', 6, 'view_session');
INSERT INTO `auth_permission` VALUES (25, 'Can add bed type', 7, 'add_bedtype');
INSERT INTO `auth_permission` VALUES (26, 'Can change bed type', 7, 'change_bedtype');
INSERT INTO `auth_permission` VALUES (27, 'Can delete bed type', 7, 'delete_bedtype');
INSERT INTO `auth_permission` VALUES (28, 'Can view bed type', 7, 'view_bedtype');
INSERT INTO `auth_permission` VALUES (29, 'Can add build manage', 8, 'add_buildmanage');
INSERT INTO `auth_permission` VALUES (30, 'Can change build manage', 8, 'change_buildmanage');
INSERT INTO `auth_permission` VALUES (31, 'Can delete build manage', 8, 'delete_buildmanage');
INSERT INTO `auth_permission` VALUES (32, 'Can view build manage', 8, 'view_buildmanage');
INSERT INTO `auth_permission` VALUES (33, 'Can add room', 9, 'add_room');
INSERT INTO `auth_permission` VALUES (34, 'Can change room', 9, 'change_room');
INSERT INTO `auth_permission` VALUES (35, 'Can delete room', 9, 'delete_room');
INSERT INTO `auth_permission` VALUES (36, 'Can view room', 9, 'view_room');
INSERT INTO `auth_permission` VALUES (37, 'Can add student', 10, 'add_student');
INSERT INTO `auth_permission` VALUES (38, 'Can change student', 10, 'change_student');
INSERT INTO `auth_permission` VALUES (39, 'Can delete student', 10, 'delete_student');
INSERT INTO `auth_permission` VALUES (40, 'Can view student', 10, 'view_student');
INSERT INTO `auth_permission` VALUES (41, 'Can add houseparent', 11, 'add_houseparent');
INSERT INTO `auth_permission` VALUES (42, 'Can change houseparent', 11, 'change_houseparent');
INSERT INTO `auth_permission` VALUES (43, 'Can delete houseparent', 11, 'delete_houseparent');
INSERT INTO `auth_permission` VALUES (44, 'Can view houseparent', 11, 'view_houseparent');
COMMIT;

-- ----------------------------
-- Table structure for auth_user
-- ----------------------------
DROP TABLE IF EXISTS `auth_user`;
CREATE TABLE `auth_user` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `password` varchar(128) NOT NULL,
  `last_login` datetime(6) DEFAULT NULL,
  `is_superuser` tinyint(1) NOT NULL,
  `username` varchar(150) NOT NULL,
  `first_name` varchar(150) NOT NULL,
  `last_name` varchar(150) NOT NULL,
  `email` varchar(254) NOT NULL,
  `is_staff` tinyint(1) NOT NULL,
  `is_active` tinyint(1) NOT NULL,
  `date_joined` datetime(6) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `username` (`username`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of auth_user
-- ----------------------------
BEGIN;
INSERT INTO `auth_user` VALUES (1, 'pbkdf2_sha256$216000$wGCyJzuLhmJb$WWXSGda45Eh/EGkJUBp5a4fvHUdFVrk2HpcTCWdC7t0=', '2021-03-22 07:47:31.590018', 1, 'admin', '', '', '', 1, 1, '2021-02-15 02:07:43.623856');
COMMIT;

-- ----------------------------
-- Table structure for auth_user_groups
-- ----------------------------
DROP TABLE IF EXISTS `auth_user_groups`;
CREATE TABLE `auth_user_groups` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) NOT NULL,
  `group_id` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `auth_user_groups_user_id_group_id_94350c0c_uniq` (`user_id`,`group_id`),
  KEY `auth_user_groups_group_id_97559544_fk_auth_group_id` (`group_id`),
  CONSTRAINT `auth_user_groups_group_id_97559544_fk_auth_group_id` FOREIGN KEY (`group_id`) REFERENCES `auth_group` (`id`),
  CONSTRAINT `auth_user_groups_user_id_6a12ed8b_fk_auth_user_id` FOREIGN KEY (`user_id`) REFERENCES `auth_user` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of auth_user_groups
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for auth_user_user_permissions
-- ----------------------------
DROP TABLE IF EXISTS `auth_user_user_permissions`;
CREATE TABLE `auth_user_user_permissions` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) NOT NULL,
  `permission_id` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `auth_user_user_permissions_user_id_permission_id_14a6b632_uniq` (`user_id`,`permission_id`),
  KEY `auth_user_user_permi_permission_id_1fbb5f2c_fk_auth_perm` (`permission_id`),
  CONSTRAINT `auth_user_user_permi_permission_id_1fbb5f2c_fk_auth_perm` FOREIGN KEY (`permission_id`) REFERENCES `auth_permission` (`id`),
  CONSTRAINT `auth_user_user_permissions_user_id_a95ead1b_fk_auth_user_id` FOREIGN KEY (`user_id`) REFERENCES `auth_user` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of auth_user_user_permissions
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for bed_type
-- ----------------------------
DROP TABLE IF EXISTS `bed_type`;
CREATE TABLE `bed_type` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `type` varchar(20) NOT NULL,
  `number` int(10) unsigned NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of bed_type
-- ----------------------------
BEGIN;
INSERT INTO `bed_type` VALUES (1, '四人间', 4);
INSERT INTO `bed_type` VALUES (2, '六人间', 6);
COMMIT;

-- ----------------------------
-- Table structure for build_manage
-- ----------------------------
DROP TABLE IF EXISTS `build_manage`;
CREATE TABLE `build_manage` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `build_name` varchar(50) NOT NULL,
  `number_of_floors` int(10) unsigned NOT NULL,
  `number_of_room_per_floor` int(10) unsigned NOT NULL,
  `details` varchar(1) NOT NULL,
  `bed_type` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `build_manage_bed_type_6e21409d_fk_bed_type_id` (`bed_type`),
  CONSTRAINT `build_manage_bed_type_6e21409d_fk_bed_type_id` FOREIGN KEY (`bed_type`) REFERENCES `bed_type` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of build_manage
-- ----------------------------
BEGIN;
INSERT INTO `build_manage` VALUES (1, '北苑一栋', 4, 4, '0', 2);
INSERT INTO `build_manage` VALUES (2, '中苑二栋', 3, 4, '1', 1);
COMMIT;

-- ----------------------------
-- Table structure for django_admin_log
-- ----------------------------
DROP TABLE IF EXISTS `django_admin_log`;
CREATE TABLE `django_admin_log` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `action_time` datetime(6) NOT NULL,
  `object_id` longtext,
  `object_repr` varchar(200) NOT NULL,
  `action_flag` smallint(5) unsigned NOT NULL,
  `change_message` longtext NOT NULL,
  `content_type_id` int(11) DEFAULT NULL,
  `user_id` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `django_admin_log_content_type_id_c4bce8eb_fk_django_co` (`content_type_id`),
  KEY `django_admin_log_user_id_c564eba6_fk_auth_user_id` (`user_id`),
  CONSTRAINT `django_admin_log_content_type_id_c4bce8eb_fk_django_co` FOREIGN KEY (`content_type_id`) REFERENCES `django_content_type` (`id`),
  CONSTRAINT `django_admin_log_user_id_c564eba6_fk_auth_user_id` FOREIGN KEY (`user_id`) REFERENCES `auth_user` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=162 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of django_admin_log
-- ----------------------------
BEGIN;
INSERT INTO `django_admin_log` VALUES (1, '2021-02-15 02:27:02.531780', '1', 'BedType object (1)', 1, '[{\"added\": {}}]', 7, 1);
INSERT INTO `django_admin_log` VALUES (2, '2021-02-15 02:27:08.640812', '2', 'BedType object (2)', 1, '[{\"added\": {}}]', 7, 1);
INSERT INTO `django_admin_log` VALUES (3, '2021-02-15 02:27:32.814055', '1', 'BuildManage object (1)', 1, '[{\"added\": {}}]', 8, 1);
INSERT INTO `django_admin_log` VALUES (4, '2021-02-15 03:56:29.101570', '1', 'BuildManage object (1)', 2, '[{\"changed\": {\"fields\": [\"Bed type\"]}}]', 8, 1);
INSERT INTO `django_admin_log` VALUES (5, '2021-02-15 04:00:19.319094', '1', 'BuildManage object (1)', 2, '[{\"changed\": {\"fields\": [\"Bed type\"]}}]', 8, 1);
INSERT INTO `django_admin_log` VALUES (6, '2021-02-15 04:07:36.769013', '1', 'BuildManage object (1)', 2, '[{\"changed\": {\"fields\": [\"Bed type\"]}}]', 8, 1);
INSERT INTO `django_admin_log` VALUES (7, '2021-02-15 04:08:42.145948', '1', 'BuildManage object (1)', 2, '[{\"changed\": {\"fields\": [\"Number of floors\", \"Number of room per floor\", \"Bed type\"]}}]', 8, 1);
INSERT INTO `django_admin_log` VALUES (8, '2021-02-15 04:09:35.620723', '1', 'BuildManage object (1)', 2, '[{\"changed\": {\"fields\": [\"Number of floors\", \"Number of room per floor\"]}}]', 8, 1);
INSERT INTO `django_admin_log` VALUES (9, '2021-02-15 08:39:13.941638', '2', '中苑二栋', 1, '[{\"added\": {}}]', 8, 1);
INSERT INTO `django_admin_log` VALUES (10, '2021-02-15 17:46:43.366252', '3', '南苑一栋', 1, '[{\"added\": {}}]', 8, 1);
INSERT INTO `django_admin_log` VALUES (11, '2021-02-15 17:46:54.552007', '2', '中苑二栋', 2, '[{\"changed\": {\"fields\": [\"\\u697c\\u5c42\\u6570\\u91cf\", \"\\u6bcf\\u5c42\\u623f\\u95f4\\u6570\\u91cf\"]}}]', 8, 1);
INSERT INTO `django_admin_log` VALUES (12, '2021-02-15 17:47:14.422294', '1', '北苑一栋', 2, '[{\"changed\": {\"fields\": [\"\\u697c\\u5c42\\u6570\\u91cf\", \"\\u6bcf\\u5c42\\u623f\\u95f4\\u6570\\u91cf\"]}}]', 8, 1);
INSERT INTO `django_admin_log` VALUES (13, '2021-02-15 17:47:28.059755', '721', '北苑一栋620', 3, '', 9, 1);
INSERT INTO `django_admin_log` VALUES (14, '2021-02-15 17:47:28.061065', '720', '北苑一栋619', 3, '', 9, 1);
INSERT INTO `django_admin_log` VALUES (15, '2021-02-15 17:47:28.061876', '719', '北苑一栋618', 3, '', 9, 1);
INSERT INTO `django_admin_log` VALUES (16, '2021-02-15 17:47:28.062606', '718', '北苑一栋617', 3, '', 9, 1);
INSERT INTO `django_admin_log` VALUES (17, '2021-02-15 17:47:28.063371', '717', '北苑一栋616', 3, '', 9, 1);
INSERT INTO `django_admin_log` VALUES (18, '2021-02-15 17:47:28.064068', '716', '北苑一栋615', 3, '', 9, 1);
INSERT INTO `django_admin_log` VALUES (19, '2021-02-15 17:47:28.064686', '715', '北苑一栋614', 3, '', 9, 1);
INSERT INTO `django_admin_log` VALUES (20, '2021-02-15 17:47:28.065306', '714', '北苑一栋613', 3, '', 9, 1);
INSERT INTO `django_admin_log` VALUES (21, '2021-02-15 17:47:28.065932', '713', '北苑一栋612', 3, '', 9, 1);
INSERT INTO `django_admin_log` VALUES (22, '2021-02-15 17:47:28.066505', '712', '北苑一栋611', 3, '', 9, 1);
INSERT INTO `django_admin_log` VALUES (23, '2021-02-15 17:47:28.067133', '711', '北苑一栋610', 3, '', 9, 1);
INSERT INTO `django_admin_log` VALUES (24, '2021-02-15 17:47:28.067789', '710', '北苑一栋609', 3, '', 9, 1);
INSERT INTO `django_admin_log` VALUES (25, '2021-02-15 17:47:28.068446', '709', '北苑一栋608', 3, '', 9, 1);
INSERT INTO `django_admin_log` VALUES (26, '2021-02-15 17:47:28.069063', '708', '北苑一栋607', 3, '', 9, 1);
INSERT INTO `django_admin_log` VALUES (27, '2021-02-15 17:47:28.069692', '707', '北苑一栋606', 3, '', 9, 1);
INSERT INTO `django_admin_log` VALUES (28, '2021-02-15 17:47:28.070295', '706', '北苑一栋605', 3, '', 9, 1);
INSERT INTO `django_admin_log` VALUES (29, '2021-02-15 17:47:28.070954', '705', '北苑一栋604', 3, '', 9, 1);
INSERT INTO `django_admin_log` VALUES (30, '2021-02-15 17:47:28.071521', '704', '北苑一栋603', 3, '', 9, 1);
INSERT INTO `django_admin_log` VALUES (31, '2021-02-15 17:47:28.072082', '703', '北苑一栋602', 3, '', 9, 1);
INSERT INTO `django_admin_log` VALUES (32, '2021-02-15 17:47:28.072644', '702', '北苑一栋601', 3, '', 9, 1);
INSERT INTO `django_admin_log` VALUES (33, '2021-02-15 17:47:28.073318', '701', '北苑一栋520', 3, '', 9, 1);
INSERT INTO `django_admin_log` VALUES (34, '2021-02-15 17:47:28.073960', '700', '北苑一栋519', 3, '', 9, 1);
INSERT INTO `django_admin_log` VALUES (35, '2021-02-15 17:47:28.074578', '699', '北苑一栋518', 3, '', 9, 1);
INSERT INTO `django_admin_log` VALUES (36, '2021-02-15 17:47:28.075120', '698', '北苑一栋517', 3, '', 9, 1);
INSERT INTO `django_admin_log` VALUES (37, '2021-02-15 17:47:28.075823', '697', '北苑一栋516', 3, '', 9, 1);
INSERT INTO `django_admin_log` VALUES (38, '2021-02-15 17:47:28.076429', '696', '北苑一栋515', 3, '', 9, 1);
INSERT INTO `django_admin_log` VALUES (39, '2021-02-15 17:47:28.077019', '695', '北苑一栋514', 3, '', 9, 1);
INSERT INTO `django_admin_log` VALUES (40, '2021-02-15 17:47:28.077592', '694', '北苑一栋513', 3, '', 9, 1);
INSERT INTO `django_admin_log` VALUES (41, '2021-02-15 17:47:28.078228', '693', '北苑一栋512', 3, '', 9, 1);
INSERT INTO `django_admin_log` VALUES (42, '2021-02-15 17:47:28.078939', '692', '北苑一栋511', 3, '', 9, 1);
INSERT INTO `django_admin_log` VALUES (43, '2021-02-15 17:47:28.079641', '691', '北苑一栋510', 3, '', 9, 1);
INSERT INTO `django_admin_log` VALUES (44, '2021-02-15 17:47:28.080278', '690', '北苑一栋509', 3, '', 9, 1);
INSERT INTO `django_admin_log` VALUES (45, '2021-02-15 17:47:28.080916', '689', '北苑一栋508', 3, '', 9, 1);
INSERT INTO `django_admin_log` VALUES (46, '2021-02-15 17:47:28.081562', '688', '北苑一栋507', 3, '', 9, 1);
INSERT INTO `django_admin_log` VALUES (47, '2021-02-15 17:47:28.082186', '687', '北苑一栋506', 3, '', 9, 1);
INSERT INTO `django_admin_log` VALUES (48, '2021-02-15 17:47:28.082808', '686', '北苑一栋505', 3, '', 9, 1);
INSERT INTO `django_admin_log` VALUES (49, '2021-02-15 17:47:28.083454', '685', '北苑一栋504', 3, '', 9, 1);
INSERT INTO `django_admin_log` VALUES (50, '2021-02-15 17:47:28.084034', '684', '北苑一栋503', 3, '', 9, 1);
INSERT INTO `django_admin_log` VALUES (51, '2021-02-15 17:47:28.084603', '683', '北苑一栋502', 3, '', 9, 1);
INSERT INTO `django_admin_log` VALUES (52, '2021-02-15 17:47:28.085260', '682', '北苑一栋501', 3, '', 9, 1);
INSERT INTO `django_admin_log` VALUES (53, '2021-02-15 17:47:28.086064', '681', '北苑一栋420', 3, '', 9, 1);
INSERT INTO `django_admin_log` VALUES (54, '2021-02-15 17:47:28.087115', '680', '北苑一栋419', 3, '', 9, 1);
INSERT INTO `django_admin_log` VALUES (55, '2021-02-15 17:47:28.087920', '679', '北苑一栋418', 3, '', 9, 1);
INSERT INTO `django_admin_log` VALUES (56, '2021-02-15 17:47:28.089116', '678', '北苑一栋417', 3, '', 9, 1);
INSERT INTO `django_admin_log` VALUES (57, '2021-02-15 17:47:28.089962', '677', '北苑一栋416', 3, '', 9, 1);
INSERT INTO `django_admin_log` VALUES (58, '2021-02-15 17:47:28.091002', '676', '北苑一栋415', 3, '', 9, 1);
INSERT INTO `django_admin_log` VALUES (59, '2021-02-15 17:47:28.091781', '675', '北苑一栋414', 3, '', 9, 1);
INSERT INTO `django_admin_log` VALUES (60, '2021-02-15 17:47:28.092408', '674', '北苑一栋413', 3, '', 9, 1);
INSERT INTO `django_admin_log` VALUES (61, '2021-02-15 17:47:28.093002', '673', '北苑一栋412', 3, '', 9, 1);
INSERT INTO `django_admin_log` VALUES (62, '2021-02-15 17:47:28.093599', '672', '北苑一栋411', 3, '', 9, 1);
INSERT INTO `django_admin_log` VALUES (63, '2021-02-15 17:47:28.094208', '671', '北苑一栋410', 3, '', 9, 1);
INSERT INTO `django_admin_log` VALUES (64, '2021-02-15 17:47:28.094785', '670', '北苑一栋409', 3, '', 9, 1);
INSERT INTO `django_admin_log` VALUES (65, '2021-02-15 17:47:28.095353', '669', '北苑一栋408', 3, '', 9, 1);
INSERT INTO `django_admin_log` VALUES (66, '2021-02-15 17:47:28.095913', '668', '北苑一栋407', 3, '', 9, 1);
INSERT INTO `django_admin_log` VALUES (67, '2021-02-15 17:47:28.096503', '667', '北苑一栋406', 3, '', 9, 1);
INSERT INTO `django_admin_log` VALUES (68, '2021-02-15 17:47:28.097057', '666', '北苑一栋405', 3, '', 9, 1);
INSERT INTO `django_admin_log` VALUES (69, '2021-02-15 17:47:28.097638', '665', '北苑一栋404', 3, '', 9, 1);
INSERT INTO `django_admin_log` VALUES (70, '2021-02-15 17:47:28.098200', '664', '北苑一栋403', 3, '', 9, 1);
INSERT INTO `django_admin_log` VALUES (71, '2021-02-15 17:47:28.098790', '663', '北苑一栋402', 3, '', 9, 1);
INSERT INTO `django_admin_log` VALUES (72, '2021-02-15 17:47:28.099354', '662', '北苑一栋401', 3, '', 9, 1);
INSERT INTO `django_admin_log` VALUES (73, '2021-02-15 17:47:28.099929', '661', '北苑一栋320', 3, '', 9, 1);
INSERT INTO `django_admin_log` VALUES (74, '2021-02-15 17:47:28.100517', '660', '北苑一栋319', 3, '', 9, 1);
INSERT INTO `django_admin_log` VALUES (75, '2021-02-15 17:47:28.101155', '659', '北苑一栋318', 3, '', 9, 1);
INSERT INTO `django_admin_log` VALUES (76, '2021-02-15 17:47:28.101882', '658', '北苑一栋317', 3, '', 9, 1);
INSERT INTO `django_admin_log` VALUES (77, '2021-02-15 17:47:28.102545', '657', '北苑一栋316', 3, '', 9, 1);
INSERT INTO `django_admin_log` VALUES (78, '2021-02-15 17:47:28.103185', '656', '北苑一栋315', 3, '', 9, 1);
INSERT INTO `django_admin_log` VALUES (79, '2021-02-15 17:47:28.103839', '655', '北苑一栋314', 3, '', 9, 1);
INSERT INTO `django_admin_log` VALUES (80, '2021-02-15 17:47:28.104555', '654', '北苑一栋313', 3, '', 9, 1);
INSERT INTO `django_admin_log` VALUES (81, '2021-02-15 17:47:28.105725', '653', '北苑一栋312', 3, '', 9, 1);
INSERT INTO `django_admin_log` VALUES (82, '2021-02-15 17:47:28.106439', '652', '北苑一栋311', 3, '', 9, 1);
INSERT INTO `django_admin_log` VALUES (83, '2021-02-15 17:47:28.107045', '651', '北苑一栋310', 3, '', 9, 1);
INSERT INTO `django_admin_log` VALUES (84, '2021-02-15 17:47:28.107669', '650', '北苑一栋309', 3, '', 9, 1);
INSERT INTO `django_admin_log` VALUES (85, '2021-02-15 17:47:28.108282', '649', '北苑一栋308', 3, '', 9, 1);
INSERT INTO `django_admin_log` VALUES (86, '2021-02-15 17:47:28.108923', '648', '北苑一栋307', 3, '', 9, 1);
INSERT INTO `django_admin_log` VALUES (87, '2021-02-15 17:47:28.109682', '647', '北苑一栋306', 3, '', 9, 1);
INSERT INTO `django_admin_log` VALUES (88, '2021-02-15 17:47:28.110617', '646', '北苑一栋305', 3, '', 9, 1);
INSERT INTO `django_admin_log` VALUES (89, '2021-02-15 17:47:28.111524', '645', '北苑一栋304', 3, '', 9, 1);
INSERT INTO `django_admin_log` VALUES (90, '2021-02-15 17:47:28.112606', '644', '北苑一栋303', 3, '', 9, 1);
INSERT INTO `django_admin_log` VALUES (91, '2021-02-15 17:47:28.113457', '643', '北苑一栋302', 3, '', 9, 1);
INSERT INTO `django_admin_log` VALUES (92, '2021-02-15 17:47:28.114514', '642', '北苑一栋301', 3, '', 9, 1);
INSERT INTO `django_admin_log` VALUES (93, '2021-02-15 17:47:28.115176', '641', '北苑一栋220', 3, '', 9, 1);
INSERT INTO `django_admin_log` VALUES (94, '2021-02-15 17:47:28.115792', '640', '北苑一栋219', 3, '', 9, 1);
INSERT INTO `django_admin_log` VALUES (95, '2021-02-15 17:47:28.116363', '639', '北苑一栋218', 3, '', 9, 1);
INSERT INTO `django_admin_log` VALUES (96, '2021-02-15 17:47:28.116968', '638', '北苑一栋217', 3, '', 9, 1);
INSERT INTO `django_admin_log` VALUES (97, '2021-02-15 17:47:28.117577', '637', '北苑一栋216', 3, '', 9, 1);
INSERT INTO `django_admin_log` VALUES (98, '2021-02-15 17:47:28.118211', '636', '北苑一栋215', 3, '', 9, 1);
INSERT INTO `django_admin_log` VALUES (99, '2021-02-15 17:47:28.118840', '635', '北苑一栋214', 3, '', 9, 1);
INSERT INTO `django_admin_log` VALUES (100, '2021-02-15 17:47:28.119477', '634', '北苑一栋213', 3, '', 9, 1);
INSERT INTO `django_admin_log` VALUES (101, '2021-02-15 17:47:28.120093', '633', '北苑一栋212', 3, '', 9, 1);
INSERT INTO `django_admin_log` VALUES (102, '2021-02-15 17:47:28.120685', '632', '北苑一栋211', 3, '', 9, 1);
INSERT INTO `django_admin_log` VALUES (103, '2021-02-15 17:47:28.121494', '631', '北苑一栋210', 3, '', 9, 1);
INSERT INTO `django_admin_log` VALUES (104, '2021-02-15 17:47:28.122467', '630', '北苑一栋209', 3, '', 9, 1);
INSERT INTO `django_admin_log` VALUES (105, '2021-02-15 17:47:28.123320', '629', '北苑一栋208', 3, '', 9, 1);
INSERT INTO `django_admin_log` VALUES (106, '2021-02-15 17:47:28.123990', '628', '北苑一栋207', 3, '', 9, 1);
INSERT INTO `django_admin_log` VALUES (107, '2021-02-15 17:47:28.124611', '627', '北苑一栋206', 3, '', 9, 1);
INSERT INTO `django_admin_log` VALUES (108, '2021-02-15 17:47:28.125240', '626', '北苑一栋205', 3, '', 9, 1);
INSERT INTO `django_admin_log` VALUES (109, '2021-02-15 17:47:28.125904', '625', '北苑一栋204', 3, '', 9, 1);
INSERT INTO `django_admin_log` VALUES (110, '2021-02-15 17:47:28.126519', '624', '北苑一栋203', 3, '', 9, 1);
INSERT INTO `django_admin_log` VALUES (111, '2021-02-15 17:47:28.127115', '623', '北苑一栋202', 3, '', 9, 1);
INSERT INTO `django_admin_log` VALUES (112, '2021-02-15 17:47:28.127710', '622', '北苑一栋201', 3, '', 9, 1);
INSERT INTO `django_admin_log` VALUES (113, '2021-02-15 17:47:37.206344', '621', '北苑一栋120', 3, '', 9, 1);
INSERT INTO `django_admin_log` VALUES (114, '2021-02-15 17:47:37.207638', '620', '北苑一栋119', 3, '', 9, 1);
INSERT INTO `django_admin_log` VALUES (115, '2021-02-15 17:47:37.208754', '619', '北苑一栋118', 3, '', 9, 1);
INSERT INTO `django_admin_log` VALUES (116, '2021-02-15 17:47:37.209541', '618', '北苑一栋117', 3, '', 9, 1);
INSERT INTO `django_admin_log` VALUES (117, '2021-02-15 17:47:37.210282', '617', '北苑一栋116', 3, '', 9, 1);
INSERT INTO `django_admin_log` VALUES (118, '2021-02-15 17:47:37.211056', '616', '北苑一栋115', 3, '', 9, 1);
INSERT INTO `django_admin_log` VALUES (119, '2021-02-15 17:47:37.211755', '615', '北苑一栋114', 3, '', 9, 1);
INSERT INTO `django_admin_log` VALUES (120, '2021-02-15 17:47:37.212351', '614', '北苑一栋113', 3, '', 9, 1);
INSERT INTO `django_admin_log` VALUES (121, '2021-02-15 17:47:37.212988', '613', '北苑一栋112', 3, '', 9, 1);
INSERT INTO `django_admin_log` VALUES (122, '2021-02-15 17:47:37.213605', '612', '北苑一栋111', 3, '', 9, 1);
INSERT INTO `django_admin_log` VALUES (123, '2021-02-15 17:47:37.214247', '611', '北苑一栋110', 3, '', 9, 1);
INSERT INTO `django_admin_log` VALUES (124, '2021-02-15 17:47:37.214830', '610', '北苑一栋109', 3, '', 9, 1);
INSERT INTO `django_admin_log` VALUES (125, '2021-02-15 17:47:37.215411', '609', '北苑一栋108', 3, '', 9, 1);
INSERT INTO `django_admin_log` VALUES (126, '2021-02-15 17:47:37.216028', '608', '北苑一栋107', 3, '', 9, 1);
INSERT INTO `django_admin_log` VALUES (127, '2021-02-15 17:47:37.216641', '607', '北苑一栋106', 3, '', 9, 1);
INSERT INTO `django_admin_log` VALUES (128, '2021-02-15 17:47:37.217224', '606', '北苑一栋105', 3, '', 9, 1);
INSERT INTO `django_admin_log` VALUES (129, '2021-02-15 17:47:37.217796', '605', '北苑一栋104', 3, '', 9, 1);
INSERT INTO `django_admin_log` VALUES (130, '2021-02-15 17:47:37.218404', '604', '北苑一栋103', 3, '', 9, 1);
INSERT INTO `django_admin_log` VALUES (131, '2021-02-15 17:47:37.219055', '603', '北苑一栋102', 3, '', 9, 1);
INSERT INTO `django_admin_log` VALUES (132, '2021-02-15 17:47:37.219662', '602', '北苑一栋101', 3, '', 9, 1);
INSERT INTO `django_admin_log` VALUES (133, '2021-02-15 17:48:06.217560', '1', '北苑一栋', 2, '[{\"changed\": {\"fields\": [\"\\u697c\\u5c42\\u6570\\u91cf\", \"\\u6bcf\\u5c42\\u623f\\u95f4\\u6570\\u91cf\"]}}]', 8, 1);
INSERT INTO `django_admin_log` VALUES (134, '2021-02-15 17:48:32.988479', '2', '中苑二栋', 2, '[{\"changed\": {\"fields\": [\"\\u5e8a\\u4f4d\\u7c7b\\u578b\"]}}]', 8, 1);
INSERT INTO `django_admin_log` VALUES (135, '2021-02-16 02:04:20.683077', '1', 'Student object (1)', 1, '[{\"added\": {}}]', 10, 1);
INSERT INTO `django_admin_log` VALUES (136, '2021-02-16 02:23:25.222964', '2', 'Student object (2)', 1, '[{\"added\": {}}]', 10, 1);
INSERT INTO `django_admin_log` VALUES (137, '2021-02-16 02:48:19.324511', '1', 'Houseparent object (1)', 1, '[{\"added\": {}}]', 11, 1);
INSERT INTO `django_admin_log` VALUES (138, '2021-02-16 04:25:42.914929', '16', 'Houseparent object (16)', 1, '[{\"added\": {}}]', 11, 1);
INSERT INTO `django_admin_log` VALUES (139, '2021-02-16 12:28:37.033557', '17', 'Houseparent object (17)', 1, '[{\"added\": {}}]', 11, 1);
INSERT INTO `django_admin_log` VALUES (140, '2021-02-16 12:29:07.300359', '18', 'Houseparent object (18)', 1, '[{\"added\": {}}]', 11, 1);
INSERT INTO `django_admin_log` VALUES (141, '2021-02-16 12:29:35.151420', '19', 'Houseparent object (19)', 1, '[{\"added\": {}}]', 11, 1);
INSERT INTO `django_admin_log` VALUES (142, '2021-02-17 03:18:57.356410', '14', 'Student object (14)', 2, '[{\"changed\": {\"fields\": [\"\\u5bdd\\u5ba4\\u53f7\"]}}]', 10, 1);
INSERT INTO `django_admin_log` VALUES (143, '2021-02-17 07:00:47.876692', '12', 'Student object (12)', 2, '[{\"changed\": {\"fields\": [\"\\u5bdd\\u5ba4\\u53f7\"]}}]', 10, 1);
INSERT INTO `django_admin_log` VALUES (144, '2021-02-17 07:01:10.527382', '12', 'Student object (12)', 2, '[{\"changed\": {\"fields\": [\"\\u5bdd\\u5ba4\\u53f7\"]}}]', 10, 1);
INSERT INTO `django_admin_log` VALUES (145, '2021-02-17 07:02:57.294455', '2', 'Student object (2)', 2, '[{\"changed\": {\"fields\": [\"\\u697c\\u5b87\\u540d\\u79f0\", \"\\u5bdd\\u5ba4\\u53f7\"]}}]', 10, 1);
INSERT INTO `django_admin_log` VALUES (146, '2021-02-17 07:13:51.233629', '3', '南苑一栋', 3, '', 8, 1);
INSERT INTO `django_admin_log` VALUES (147, '2021-02-17 07:16:45.962467', '729', '南苑一栋204', 3, '', 9, 1);
INSERT INTO `django_admin_log` VALUES (148, '2021-02-17 07:16:45.963804', '728', '南苑一栋203', 3, '', 9, 1);
INSERT INTO `django_admin_log` VALUES (149, '2021-02-17 07:16:45.964906', '727', '南苑一栋202', 3, '', 9, 1);
INSERT INTO `django_admin_log` VALUES (150, '2021-02-17 07:16:45.966529', '726', '南苑一栋201', 3, '', 9, 1);
INSERT INTO `django_admin_log` VALUES (151, '2021-02-17 07:16:45.967489', '725', '南苑一栋104', 3, '', 9, 1);
INSERT INTO `django_admin_log` VALUES (152, '2021-02-17 07:16:45.968313', '724', '南苑一栋103', 3, '', 9, 1);
INSERT INTO `django_admin_log` VALUES (153, '2021-02-17 07:16:45.969618', '723', '南苑一栋102', 3, '', 9, 1);
INSERT INTO `django_admin_log` VALUES (154, '2021-02-17 07:16:45.970266', '722', '南苑一栋101', 3, '', 9, 1);
INSERT INTO `django_admin_log` VALUES (155, '2021-02-17 07:16:52.830569', '3', '南苑一栋', 3, '', 8, 1);
INSERT INTO `django_admin_log` VALUES (156, '2021-02-17 07:17:22.796125', '16', 'Houseparent object (16)', 2, '[{\"changed\": {\"fields\": [\"\\u697c\\u5b87\\u540d\\u79f0\"]}}]', 11, 1);
INSERT INTO `django_admin_log` VALUES (157, '2021-02-17 07:17:27.312648', '18', 'Houseparent object (18)', 2, '[{\"changed\": {\"fields\": [\"\\u697c\\u5b87\\u540d\\u79f0\"]}}]', 11, 1);
INSERT INTO `django_admin_log` VALUES (158, '2021-02-17 07:17:35.849705', '3', '南苑一栋', 3, '', 8, 1);
INSERT INTO `django_admin_log` VALUES (159, '2021-02-17 08:00:51.997323', '12', 'Student object (12)', 2, '[{\"changed\": {\"fields\": [\"\\u5bdd\\u5ba4\\u53f7\"]}}]', 10, 1);
INSERT INTO `django_admin_log` VALUES (160, '2021-02-17 08:00:59.440082', '6', 'Student object (6)', 2, '[{\"changed\": {\"fields\": [\"\\u5bdd\\u5ba4\\u53f7\"]}}]', 10, 1);
INSERT INTO `django_admin_log` VALUES (161, '2021-02-17 08:01:20.618952', '6', 'Student object (6)', 2, '[{\"changed\": {\"fields\": [\"\\u5bdd\\u5ba4\\u53f7\"]}}]', 10, 1);
COMMIT;

-- ----------------------------
-- Table structure for django_content_type
-- ----------------------------
DROP TABLE IF EXISTS `django_content_type`;
CREATE TABLE `django_content_type` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `app_label` varchar(100) NOT NULL,
  `model` varchar(100) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `django_content_type_app_label_model_76bd3d3b_uniq` (`app_label`,`model`)
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of django_content_type
-- ----------------------------
BEGIN;
INSERT INTO `django_content_type` VALUES (1, 'admin', 'logentry');
INSERT INTO `django_content_type` VALUES (3, 'auth', 'group');
INSERT INTO `django_content_type` VALUES (2, 'auth', 'permission');
INSERT INTO `django_content_type` VALUES (4, 'auth', 'user');
INSERT INTO `django_content_type` VALUES (7, 'build_manage', 'bedtype');
INSERT INTO `django_content_type` VALUES (8, 'build_manage', 'buildmanage');
INSERT INTO `django_content_type` VALUES (9, 'build_manage', 'room');
INSERT INTO `django_content_type` VALUES (5, 'contenttypes', 'contenttype');
INSERT INTO `django_content_type` VALUES (6, 'sessions', 'session');
INSERT INTO `django_content_type` VALUES (11, 'users', 'houseparent');
INSERT INTO `django_content_type` VALUES (10, 'users', 'student');
COMMIT;

-- ----------------------------
-- Table structure for django_migrations
-- ----------------------------
DROP TABLE IF EXISTS `django_migrations`;
CREATE TABLE `django_migrations` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `app` varchar(255) NOT NULL,
  `name` varchar(255) NOT NULL,
  `applied` datetime(6) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=34 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of django_migrations
-- ----------------------------
BEGIN;
INSERT INTO `django_migrations` VALUES (1, 'contenttypes', '0001_initial', '2021-02-15 02:01:39.878228');
INSERT INTO `django_migrations` VALUES (2, 'auth', '0001_initial', '2021-02-15 02:01:40.103818');
INSERT INTO `django_migrations` VALUES (3, 'admin', '0001_initial', '2021-02-15 02:01:40.548118');
INSERT INTO `django_migrations` VALUES (4, 'admin', '0002_logentry_remove_auto_add', '2021-02-15 02:01:40.633742');
INSERT INTO `django_migrations` VALUES (5, 'admin', '0003_logentry_add_action_flag_choices', '2021-02-15 02:01:40.641924');
INSERT INTO `django_migrations` VALUES (6, 'contenttypes', '0002_remove_content_type_name', '2021-02-15 02:01:40.734951');
INSERT INTO `django_migrations` VALUES (7, 'auth', '0002_alter_permission_name_max_length', '2021-02-15 02:01:40.786117');
INSERT INTO `django_migrations` VALUES (8, 'auth', '0003_alter_user_email_max_length', '2021-02-15 02:01:40.830192');
INSERT INTO `django_migrations` VALUES (9, 'auth', '0004_alter_user_username_opts', '2021-02-15 02:01:40.839323');
INSERT INTO `django_migrations` VALUES (10, 'auth', '0005_alter_user_last_login_null', '2021-02-15 02:01:40.883195');
INSERT INTO `django_migrations` VALUES (11, 'auth', '0006_require_contenttypes_0002', '2021-02-15 02:01:40.885362');
INSERT INTO `django_migrations` VALUES (12, 'auth', '0007_alter_validators_add_error_messages', '2021-02-15 02:01:40.893029');
INSERT INTO `django_migrations` VALUES (13, 'auth', '0008_alter_user_username_max_length', '2021-02-15 02:01:40.963543');
INSERT INTO `django_migrations` VALUES (14, 'auth', '0009_alter_user_last_name_max_length', '2021-02-15 02:01:41.011747');
INSERT INTO `django_migrations` VALUES (15, 'auth', '0010_alter_group_name_max_length', '2021-02-15 02:01:41.061594');
INSERT INTO `django_migrations` VALUES (16, 'auth', '0011_update_proxy_permissions', '2021-02-15 02:01:41.072713');
INSERT INTO `django_migrations` VALUES (17, 'auth', '0012_alter_user_first_name_max_length', '2021-02-15 02:01:41.115256');
INSERT INTO `django_migrations` VALUES (18, 'build_manage', '0001_initial', '2021-02-15 02:01:41.190498');
INSERT INTO `django_migrations` VALUES (19, 'sessions', '0001_initial', '2021-02-15 02:01:41.265228');
INSERT INTO `django_migrations` VALUES (20, 'build_manage', '0002_auto_20210215_1059', '2021-02-15 02:59:41.526991');
INSERT INTO `django_migrations` VALUES (21, 'build_manage', '0003_room', '2021-02-15 03:52:37.235742');
INSERT INTO `django_migrations` VALUES (22, 'build_manage', '0004_auto_20210215_1201', '2021-02-15 04:01:20.993428');
INSERT INTO `django_migrations` VALUES (23, 'build_manage', '0005_auto_20210215_1648', '2021-02-15 08:49:48.611857');
INSERT INTO `django_migrations` VALUES (24, 'build_manage', '0006_auto_20210216_0139', '2021-02-15 17:39:29.954094');
INSERT INTO `django_migrations` VALUES (25, 'users', '0001_initial', '2021-02-15 17:39:30.052674');
INSERT INTO `django_migrations` VALUES (26, 'users', '0002_auto_20210216_0953', '2021-02-16 01:53:20.358201');
INSERT INTO `django_migrations` VALUES (27, 'users', '0003_auto_20210216_0957', '2021-02-16 01:57:16.858608');
INSERT INTO `django_migrations` VALUES (28, 'users', '0004_student_sex', '2021-02-16 03:52:19.411565');
INSERT INTO `django_migrations` VALUES (29, 'build_manage', '0007_room_actual_number', '2021-02-16 12:50:18.221796');
INSERT INTO `django_migrations` VALUES (30, 'users', '0005_auto_20210216_2050', '2021-02-16 12:50:18.307914');
INSERT INTO `django_migrations` VALUES (31, 'build_manage', '0008_auto_20210217_1111', '2021-02-17 03:12:03.784365');
INSERT INTO `django_migrations` VALUES (32, 'build_manage', '0009_auto_20210217_1552', '2021-02-17 07:53:00.130944');
INSERT INTO `django_migrations` VALUES (33, 'users', '0006_auto_20210217_1552', '2021-02-17 07:53:00.239000');
COMMIT;

-- ----------------------------
-- Table structure for django_session
-- ----------------------------
DROP TABLE IF EXISTS `django_session`;
CREATE TABLE `django_session` (
  `session_key` varchar(40) NOT NULL,
  `session_data` longtext NOT NULL,
  `expire_date` datetime(6) NOT NULL,
  PRIMARY KEY (`session_key`),
  KEY `django_session_expire_date_a5c62663` (`expire_date`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of django_session
-- ----------------------------
BEGIN;
INSERT INTO `django_session` VALUES ('sjt056sbsptva3lzvg6pan5fjijs3yer', '.eJxVjDsOgzAQRO-yNbJs8A_K9LkBElp7l0BCQAJcRbl7cESRNFPMezMvGAkaZQuY8cnQQJtcQHWklrZNRhsvFRQQ0jhRl92ygA7TPnRp4_XbQBZ-uoDxwXMGdMf5toi4zPs6BpEVcdJNXBfi6XK6fwcDbsOxlkTOOcVVDBoNhiDZ99bbXlqkuoxYO8-uZl-h0cTaaHmgKC0rdEpFeH8A6TlGXg:1lOFHf:5hXfr5yv5h1lIS-qE3b0eApovZ0JPEhaCFQejiJRLI0', '2021-04-05 07:47:31.592681');
COMMIT;

-- ----------------------------
-- Table structure for houseparent
-- ----------------------------
DROP TABLE IF EXISTS `houseparent`;
CREATE TABLE `houseparent` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `username` varchar(30) NOT NULL,
  `password` varchar(30) NOT NULL,
  `name` varchar(20) NOT NULL,
  `phone` varchar(11) DEFAULT NULL,
  `sex` varchar(1) NOT NULL,
  `build_id` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `houseparent_build_id_4a0ac495_fk_build_manage_id` (`build_id`),
  CONSTRAINT `houseparent_build_id_4a0ac495_fk_build_manage_id` FOREIGN KEY (`build_id`) REFERENCES `build_manage` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=20 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of houseparent
-- ----------------------------
BEGIN;
INSERT INTO `houseparent` VALUES (16, 'admin01', 'admin01', '管理员01', '18308312345', '0', 2);
INSERT INTO `houseparent` VALUES (17, 'admin02', 'admin02', '管理员02', '18623617667', '0', 1);
INSERT INTO `houseparent` VALUES (18, 'admin03', 'admin03', '管理员03', '18623616677', '0', 1);
INSERT INTO `houseparent` VALUES (19, 'admin04', 'admin04', '管理员04', '18502305260', '0', 2);
COMMIT;

-- ----------------------------
-- Table structure for room
-- ----------------------------
DROP TABLE IF EXISTS `room`;
CREATE TABLE `room` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(30) NOT NULL,
  `number` int(11) NOT NULL,
  `bed_type` int(11) NOT NULL,
  `build_id` int(11) NOT NULL,
  `actual_number` int(10) unsigned NOT NULL,
  PRIMARY KEY (`id`),
  KEY `room_bed_type_884254f8_fk_bed_type_id` (`bed_type`),
  KEY `room_build_id_f6538e25_fk_build_manage_id` (`build_id`),
  CONSTRAINT `room_bed_type_884254f8_fk_bed_type_id` FOREIGN KEY (`bed_type`) REFERENCES `bed_type` (`id`),
  CONSTRAINT `room_build_id_f6538e25_fk_build_manage_id` FOREIGN KEY (`build_id`) REFERENCES `build_manage` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=758 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of room
-- ----------------------------
BEGIN;
INSERT INTO `room` VALUES (730, '中苑二栋101', 4, 1, 2, 4);
INSERT INTO `room` VALUES (731, '中苑二栋102', 4, 1, 2, 2);
INSERT INTO `room` VALUES (732, '中苑二栋103', 4, 1, 2, 3);
INSERT INTO `room` VALUES (733, '中苑二栋104', 4, 1, 2, 3);
INSERT INTO `room` VALUES (734, '中苑二栋201', 4, 1, 2, 1);
INSERT INTO `room` VALUES (735, '中苑二栋202', 4, 1, 2, 1);
INSERT INTO `room` VALUES (736, '中苑二栋203', 4, 1, 2, 1);
INSERT INTO `room` VALUES (737, '中苑二栋204', 4, 1, 2, 1);
INSERT INTO `room` VALUES (738, '中苑二栋301', 4, 1, 2, 1);
INSERT INTO `room` VALUES (739, '中苑二栋302', 4, 1, 2, 1);
INSERT INTO `room` VALUES (740, '中苑二栋303', 4, 1, 2, 1);
INSERT INTO `room` VALUES (741, '中苑二栋304', 4, 1, 2, 1);
INSERT INTO `room` VALUES (742, '北苑一栋101', 6, 2, 1, 4);
INSERT INTO `room` VALUES (743, '北苑一栋102', 6, 2, 1, 3);
INSERT INTO `room` VALUES (744, '北苑一栋103', 6, 2, 1, 1);
INSERT INTO `room` VALUES (745, '北苑一栋104', 6, 2, 1, 1);
INSERT INTO `room` VALUES (746, '北苑一栋201', 6, 2, 1, 1);
INSERT INTO `room` VALUES (747, '北苑一栋202', 6, 2, 1, 1);
INSERT INTO `room` VALUES (748, '北苑一栋203', 6, 2, 1, 2);
INSERT INTO `room` VALUES (749, '北苑一栋204', 6, 2, 1, 1);
INSERT INTO `room` VALUES (750, '北苑一栋301', 6, 2, 1, 0);
INSERT INTO `room` VALUES (751, '北苑一栋302', 6, 2, 1, 1);
INSERT INTO `room` VALUES (752, '北苑一栋303', 6, 2, 1, 0);
INSERT INTO `room` VALUES (753, '北苑一栋304', 6, 2, 1, 0);
INSERT INTO `room` VALUES (754, '北苑一栋401', 6, 2, 1, 0);
INSERT INTO `room` VALUES (755, '北苑一栋402', 6, 2, 1, 0);
INSERT INTO `room` VALUES (756, '北苑一栋403', 6, 2, 1, 0);
INSERT INTO `room` VALUES (757, '北苑一栋404', 6, 2, 1, 0);
COMMIT;

-- ----------------------------
-- Table structure for student
-- ----------------------------
DROP TABLE IF EXISTS `student`;
CREATE TABLE `student` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(20) NOT NULL,
  `student_number` varchar(30) NOT NULL,
  `phone` varchar(11) DEFAULT NULL,
  `room_id` int(11) DEFAULT NULL,
  `build_id` int(11) DEFAULT NULL,
  `sex` varchar(1) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `student_build_id_37eebd1e_fk_build_manage_id` (`build_id`),
  KEY `student_room_id_5e8885ed_fk_room_id` (`room_id`),
  CONSTRAINT `student_build_id_37eebd1e_fk_build_manage_id` FOREIGN KEY (`build_id`) REFERENCES `build_manage` (`id`),
  CONSTRAINT `student_room_id_5e8885ed_fk_room_id` FOREIGN KEY (`room_id`) REFERENCES `room` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=37 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of student
-- ----------------------------
BEGIN;
INSERT INTO `student` VALUES (1, '张三', '1712085001', '13525607788', 730, 2, '1');
INSERT INTO `student` VALUES (2, '刘欣', '1712085002', '19987694763', 743, 1, '0');
INSERT INTO `student` VALUES (3, '李四', '1712085005', '15389665823', 730, 2, '1');
INSERT INTO `student` VALUES (4, '王五', '1712085016', '19945682789', 730, 2, '1');
INSERT INTO `student` VALUES (5, '李林刚', '1712085189', '15633889201', 731, 2, '1');
INSERT INTO `student` VALUES (6, '姚崇霖', '1712085080', '18087898777', 743, 1, '0');
INSERT INTO `student` VALUES (7, '冯卓立', '1712085122', '18973627564', 731, 2, '1');
INSERT INTO `student` VALUES (8, '杨华旺', '1712086178', '18883529877', 732, 2, '1');
INSERT INTO `student` VALUES (9, '左超', '1712085128', '15223069373', 732, 2, '1');
INSERT INTO `student` VALUES (10, '王斌斌', '1712086055', '13225862555', 732, 2, '1');
INSERT INTO `student` VALUES (11, '雷浩', '1712085130', '15696324568', NULL, NULL, '1');
INSERT INTO `student` VALUES (12, '庞淑芳', '1712085135', '15884736201', 743, 1, '0');
INSERT INTO `student` VALUES (13, '孙嘉岑', '1712085142', '15736579668', 733, 2, '1');
INSERT INTO `student` VALUES (14, '聂雨亭', '1712085009', '17623830737', 742, 1, '0');
INSERT INTO `student` VALUES (15, '加班', '1712085020', '13802947724', 730, 2, '1');
INSERT INTO `student` VALUES (16, '王奇令', '1712085023', '18202362301', 733, 2, '1');
INSERT INTO `student` VALUES (17, '李俊陶', '1712085025', '18223488108', 733, 2, '1');
INSERT INTO `student` VALUES (18, '范德菊', '1712085026', '13368206852', 746, 1, '0');
INSERT INTO `student` VALUES (19, '马礼政', '1712085027', '15736158996', 734, 2, '1');
INSERT INTO `student` VALUES (20, '陈小越', '1712085040', '15102367914', 748, 1, '0');
INSERT INTO `student` VALUES (21, '罗圆圆', '1712085053', '13677647716', 749, 1, '0');
INSERT INTO `student` VALUES (22, '匡雄渝', '1712085055', '18723580367', 735, 2, '1');
INSERT INTO `student` VALUES (23, '谢清山', '1712085056', '13452710742', 736, 2, '1');
INSERT INTO `student` VALUES (24, '刘棋', '1712085057', '15730510973', 737, 2, '1');
INSERT INTO `student` VALUES (25, '王锦标', '1712085058', '15736607949', 738, 2, '1');
INSERT INTO `student` VALUES (26, '陈娇', '1712086043', '15523006318', 742, 1, '0');
INSERT INTO `student` VALUES (27, '唐明婕', '1712086109', '15281683337', 742, 1, '0');
INSERT INTO `student` VALUES (28, '李建蓉', '1712086131', '18290557668', 744, 1, '0');
INSERT INTO `student` VALUES (29, '张思思', '1712086140', '15178798003', 745, 1, '0');
INSERT INTO `student` VALUES (30, '曾祥婷', '1712086146', '15823974141', 742, 1, '0');
INSERT INTO `student` VALUES (31, '李青青', '1712086147', '18223862417', 747, 1, '0');
INSERT INTO `student` VALUES (32, '王雪', '1712086151', '17815379599', 748, 1, '0');
INSERT INTO `student` VALUES (33, '邹莉', '1712086152', '18315003286', 751, 1, '0');
INSERT INTO `student` VALUES (34, '赵鑫晨', '1712086156', '18280196578', 739, 2, '1');
INSERT INTO `student` VALUES (35, '冯文博', '1712086158', '18883721203', 740, 2, '1');
INSERT INTO `student` VALUES (36, '向阳', '1712086163', '15215238613', 741, 2, '1');
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
